Calculating Work Hours in a Day

您所在的位置：网站首页 › confluence storage format confluence data center and › Calculating Work Hours in a Day

Calculating Work Hours in a Day

2023-03-29 04:45| 来源: 网络整理| 查看: 265

Calculating Work Hours in a Day Calculating Work Hours in a Day Scenario

By combining Reporting and Visibility, you are able to create forms that can take your input data and perform calculations and then output the results.

For example, this recipe allows you to create a table that is able to list specific work hours by project per day minus time taken for lunch breaks.

Result

Recipe

Apps

Reporting for Confluence Server & Data Center, Scaffolding Forms & Templates for Confluence Server and Data Center, Visibility for Confluence

Level

Intermediate

Estimated time

30 minutes

Macros

Local Reporter, Report Column, Report Eval, Report Info, Report Table

Suppliers

Scaffold Data Supplier

Storage format

You can copy and paste this code into the Confluence Source Editor:

edit INLINE

project 1

Job

Start

End

Lunch Break

Comments

job INLINE

dd/MM/yyyy HH:mm start true INLINE

dd/MM/yyyy HH:mm end true INLINE

false break true INLINE

10 10

15 15

20 20

25 25

30 30

35 35

40 40

45 45

50 50

55 55

60 60

comments INLINE

view INLINE

data:project

Job

richtext richtext data:job

Start

dd/MM/yyyy HH:mm data:start

End

dd/MM/yyyy HH:mm data:end

Lunch Break

data:break

Comments

richtext data:comments

Total Work Hours

#0.00 BLOCK test2 date:milliseconds% - %data:start > date:milliseconds%) - (%data:break > collection:first > text:as number%) * 60 * 1000) / (1000 * 60 * 60 )]]>

Macro structure

You can recreate the example in the editor view:

Steps

N/A

Line-by-Line Explanation

N/A

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close

【本文地址】

公司简介

联系我们